/*
 Navicat Premium Data Transfer

 Source Server         : Mysql-166
 Source Server Type    : MySQL
 Source Server Version : 50727
 Source Host           : 192.168.3.166:3306
 Source Schema         : xtl

 Target Server Type    : MySQL
 Target Server Version : 50727
 File Encoding         : 65001

 Date: 23/12/2021 12:34:40
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for x_database
-- ----------------------------
DROP TABLE IF EXISTS `x_database`;
CREATE TABLE `x_database` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `database_type` varchar(10) DEFAULT NULL,
  `database_contype` varchar(10) DEFAULT NULL,
  `host_name` varchar(255) DEFAULT NULL,
  `database_name` varchar(50) DEFAULT NULL,
  `port` int(11) DEFAULT NULL,
  `created_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `servername` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of x_database
-- ----------------------------
BEGIN;
INSERT INTO `x_database` VALUES (1, 'local_db', 'MYSQL', 'Native', '127.0.0.1', 'test', 3308, NULL, NULL, 'root', 'root', '');
INSERT INTO `x_database` VALUES (2, 'test01', 'MYSQL', 'Native', '127.0.0.1', 'test', 3308, NULL, NULL, 'root', 'root', '');
INSERT INTO `x_database` VALUES (3, 'test12', 'MYSQL', 'Native', '127.0.0.1', 'test', 3308, '2021-02-04 09:34:10', '2021-02-04 09:34:10', 'root', 'root', '');
COMMIT;

-- ----------------------------
-- Table structure for x_dept
-- ----------------------------
DROP TABLE IF EXISTS `x_dept`;
CREATE TABLE `x_dept` (
  `dept_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `parent_id` bigint(20) DEFAULT '0',
  `ancestors` varchar(50) DEFAULT '',
  `dept_name` varchar(30) DEFAULT '',
  `order_num` int(4) DEFAULT '0',
  `leader` varchar(20) DEFAULT NULL,
  `phone` varchar(11) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `status` char(1) DEFAULT '0',
  `del_flag` char(1) DEFAULT '0',
  `create_by` varchar(64) DEFAULT '',
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(64) DEFAULT '',
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`dept_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for x_dict
-- ----------------------------
DROP TABLE IF EXISTS `x_dict`;
CREATE TABLE `x_dict` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `dict_name` varchar(100) NOT NULL,
  `dict_id` varchar(100) DEFAULT NULL,
  `dict_key` varchar(100) DEFAULT NULL,
  `dict_value` varchar(500) DEFAULT NULL,
  `order_num` varchar(10) DEFAULT NULL,
  `dict_desc` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of x_dict
-- ----------------------------
BEGIN;
INSERT INTO `x_dict` VALUES (1, '可支持的数据库', 'supported_type_database', '1', 'MYSQL', '1', 'MYSQL');
INSERT INTO `x_dict` VALUES (2, '可支持的数据库', 'supported_type_database', '2', 'ORACLE', '2', 'ORACLE');
INSERT INTO `x_dict` VALUES (3, '可支持的数据库', 'supported_type_database', '3', 'AS400', '3', 'AS400');
INSERT INTO `x_dict` VALUES (4, '可支持的数据库', 'supported_type_database', '4', 'ACCESS', '4', 'ACCESS');
INSERT INTO `x_dict` VALUES (5, '可支持的数据库', 'supported_type_database', '5', 'MSSQL', '5', 'MSSQL');
INSERT INTO `x_dict` VALUES (6, '可支持的数据库', 'supported_type_database', '6', 'DB2', '6', 'DB2');
INSERT INTO `x_dict` VALUES (7, '可支持的数据库', 'supported_type_database', '7', 'POSTGRES', '7', 'POSTGRES');
INSERT INTO `x_dict` VALUES (8, '可支持的数据库', 'supported_type_database', '8', 'CACHE', '8', 'CACHE');
INSERT INTO `x_dict` VALUES (9, '可支持的数据库', 'supported_type_database', '9', 'INFORMIX', '9', 'INFORMIX');
INSERT INTO `x_dict` VALUES (10, '可支持的数据库', 'supported_type_database', '10', 'SYBASE', '10', 'SYBASE');
INSERT INTO `x_dict` VALUES (11, '可支持的数据库', 'supported_type_database', '11', 'GUPTA', '11', 'GUPTA');
INSERT INTO `x_dict` VALUES (12, '可支持的数据库', 'supported_type_database', '12', 'DBASE', '12', 'DBASE');
INSERT INTO `x_dict` VALUES (13, '可支持的数据库', 'supported_type_database', '13', 'FIREBIRD', '13', 'FIREBIRD');
INSERT INTO `x_dict` VALUES (14, '可支持的数据库', 'supported_type_database', '14', 'SAPDB', '14', 'SAPDB');
INSERT INTO `x_dict` VALUES (15, '可支持的数据库', 'supported_type_database', '15', 'HYPERSONIC', '15', 'HYPERSONIC');
INSERT INTO `x_dict` VALUES (16, '可支持的数据库', 'supported_type_database', '16', 'GENERIC', '16', 'GENERIC');
INSERT INTO `x_dict` VALUES (17, '可支持的数据库', 'supported_type_database', '17', 'SAPR3', '17', 'SAPR3');
INSERT INTO `x_dict` VALUES (18, '可支持的数据库', 'supported_type_database', '18', 'INGRES', '18', 'INGRES');
INSERT INTO `x_dict` VALUES (19, '可支持的数据库', 'supported_type_database', '19', 'INTERBASE', '19', 'INTERBASE');
INSERT INTO `x_dict` VALUES (20, '可支持的数据库', 'supported_type_database', '20', 'EXTENDB', '20', 'EXTENDB');
INSERT INTO `x_dict` VALUES (21, '可支持的数据库', 'supported_type_database', '21', 'TERADATA', '21', 'TERADATA');
INSERT INTO `x_dict` VALUES (22, '可支持的数据库', 'supported_type_database', '22', 'ORACLE_RDB', '22', 'ORACLE_RDB');
INSERT INTO `x_dict` VALUES (23, '可支持的数据库', 'supported_type_database', '23', 'H2', '23', 'H2');
INSERT INTO `x_dict` VALUES (24, '可支持的数据库', 'supported_type_database', '24', 'NETEZZA', '24', 'NETEZZA');
INSERT INTO `x_dict` VALUES (25, '可支持的数据库', 'supported_type_database', '25', 'UNIVERSE', '25', 'UNIVERSE');
INSERT INTO `x_dict` VALUES (26, '可支持的数据库', 'supported_type_database', '26', 'SQLITE', '26', 'SQLITE');
INSERT INTO `x_dict` VALUES (27, '可支持的数据库', 'supported_type_database', '27', 'DERBY', '27', 'DERBY');
INSERT INTO `x_dict` VALUES (28, '可支持的数据库', 'supported_type_database', '28', 'REMEDY_AR_SYSTEM', '28', 'REMEDY_AR_SYSTEM');
INSERT INTO `x_dict` VALUES (29, '可支持的数据库', 'supported_type_database', '29', 'PALO', '29', 'PALO');
INSERT INTO `x_dict` VALUES (30, '可支持的数据库', 'supported_type_database', '30', 'SYBASEIQ', '30', 'SYBASEIQ');
INSERT INTO `x_dict` VALUES (31, '可支持的数据库', 'supported_type_database', '31', 'GREENPLUM', '31', 'GREENPLUM');
INSERT INTO `x_dict` VALUES (32, '可支持的数据库', 'supported_type_database', '32', 'MONETDB', '32', 'MONETDB');
INSERT INTO `x_dict` VALUES (33, '可支持的数据库', 'supported_type_database', '33', 'KINGBASEES', '33', 'KINGBASEES');
INSERT INTO `x_dict` VALUES (34, '可支持的数据库', 'supported_type_database', '34', 'VERTICA', '34', 'VERTICA');
INSERT INTO `x_dict` VALUES (35, '可支持的数据库', 'supported_type_database', '35', 'NEOVIEW', '35', 'NEOVIEW');
INSERT INTO `x_dict` VALUES (36, '可支持的数据库', 'supported_type_database', '36', 'LUCIDDB', '36', 'LUCIDDB');
INSERT INTO `x_dict` VALUES (37, '作业状态', 'supported_job_status', '10', '等待中', '1', '等待中');
INSERT INTO `x_dict` VALUES (38, '作业状态', 'supported_job_status', '21', '终止中', '1', '终止中');
INSERT INTO `x_dict` VALUES (39, '作业状态', 'supported_job_status', '30', '已终止', '1', '已终止');
INSERT INTO `x_dict` VALUES (40, '作业状态', 'supported_job_status', '20', '运行中', '1', '运行中');
INSERT INTO `x_dict` VALUES (41, '作业状态', 'supported_job_status', '40', '已结束', '1', '已结束');
INSERT INTO `x_dict` VALUES (42, '转换状态', 'supported_trans_status', '10', '等待中', '1', '等待中');
INSERT INTO `x_dict` VALUES (43, '转换状态', 'supported_trans_status', '70', '终止中', '1', '终止中');
INSERT INTO `x_dict` VALUES (44, '转换状态', 'supported_trans_status', '30', '已终止', '1', '已终止');
INSERT INTO `x_dict` VALUES (45, '转换状态', 'supported_trans_status', '50', '运行中', '1', '运行中');
INSERT INTO `x_dict` VALUES (46, '转换状态', 'supported_trans_status', '40', '已结束', '1', '已结束');
INSERT INTO `x_dict` VALUES (47, '转换状态', 'supported_trans_status', '20', '初始化中', '1', '初始化中');
INSERT INTO `x_dict` VALUES (48, '转换状态', 'supported_trans_status', '21', '准备中', '1', '准备中');
INSERT INTO `x_dict` VALUES (49, '转换状态', 'supported_trans_status', '60', '已暂停', '1', '已暂停');
INSERT INTO `x_dict` VALUES (50, '日志级别', 'supported_log_level', 'basic', '基本级别', '1', '基本级别');
INSERT INTO `x_dict` VALUES (51, '日志级别', 'supported_log_level', 'detail', '详细级别', '1', '详细级别');
INSERT INTO `x_dict` VALUES (52, '日志级别', 'supported_log_level', 'error', '异常级别', '1', '异常级别');
INSERT INTO `x_dict` VALUES (53, '日志级别', 'supported_log_level', 'debug', '调试级别', '1', '调试级别');
INSERT INTO `x_dict` VALUES (54, '日志级别', 'supported_log_level', 'minimal', '最小级别\n', '1', '最小级别\n');
INSERT INTO `x_dict` VALUES (55, '日志级别', 'supported_log_level', 'rowlevel', '行级别', '1', '行级别');
INSERT INTO `x_dict` VALUES (56, '日志级别', 'supported_log_level', 'Nothing', '无级别', '1', '无级别');
INSERT INTO `x_dict` VALUES (57, '作业状态', 'supported_job_status', '-1', '未知状态', '1', '未知状态');
INSERT INTO `x_dict` VALUES (58, '转换状态', 'supported_trans_status', '-1', '未知状态', '1', '未知状态');
INSERT INTO `x_dict` VALUES (59, '转换状态', 'supported_trans_status', '99', '异常停止', '1', '异常停止');
INSERT INTO `x_dict` VALUES (60, '作业状态', 'supported_job_status', '99', '异常停止', '1', '异常停止');
INSERT INTO `x_dict` VALUES (61, '操作类型', 'supported_oper_type', 'OTHER', '其他', '1', '其他');
INSERT INTO `x_dict` VALUES (62, '操作类型', 'supported_oper_type', 'INSERT', '新增', '1', '新增');
INSERT INTO `x_dict` VALUES (63, '操作类型', 'supported_oper_type', 'UPDATE', '更新', '1', '更新');
INSERT INTO `x_dict` VALUES (64, '操作类型', 'supported_oper_type', 'DELETE', '删除', '1', '删除');
INSERT INTO `x_dict` VALUES (65, '操作类型', 'supported_oper_type', 'LOGOUT', '注销', '1', '注销');
INSERT INTO `x_dict` VALUES (66, '操作类型', 'supported_oper_type', 'CLEAR', '清理', '1', '清理');
INSERT INTO `x_dict` VALUES (67, '操作类型', 'supported_oper_type', 'START', '启动任务', '1', '启动任务');
INSERT INTO `x_dict` VALUES (68, '操作类型', 'supported_oper_type', 'STOP', '终止任务', '1', '终止任务');
INSERT INTO `x_dict` VALUES (69, '操作类型', 'supported_oper_type', 'SCHEDULER', '添加定时', '1', '添加定时');
INSERT INTO `x_dict` VALUES (70, '操作类型', 'supported_oper_type', 'REMOTE_START', '远程启动', '1', '远程启动');
INSERT INTO `x_dict` VALUES (71, '操作类型', 'supported_oper_type', 'REMOTE_STOP', '远程停止', '1', '远程停止');
COMMIT;

-- ----------------------------
-- Table structure for x_job
-- ----------------------------
DROP TABLE IF EXISTS `x_job`;
CREATE TABLE `x_job` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `job_id` varchar(100) DEFAULT NULL,
  `job_name` varchar(200) NOT NULL,
  `job_description` varchar(500) DEFAULT NULL,
  `job_type` varchar(5) DEFAULT NULL,
  `job_path` varchar(200) DEFAULT NULL,
  `job_repository_id` varchar(30) DEFAULT NULL,
  `job_log_level` varchar(10) DEFAULT NULL,
  `job_status` varchar(10) DEFAULT NULL,
  `is_del` char(2) DEFAULT NULL,
  `created_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `is_monitor_enabled` char(2) DEFAULT NULL,
  `tpl_key` varchar(150) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of x_job
-- ----------------------------
BEGIN;
INSERT INTO `x_job` VALUES (31, '117', 'main', '重庆仁品', 'db', '/仁品数据同步', '1326379690046259200', 'basic', NULL, '0', '2021-12-22 11:37:02', '2021-12-22 11:37:02', '1', '');
COMMIT;

-- ----------------------------
-- Table structure for x_log
-- ----------------------------
DROP TABLE IF EXISTS `x_log`;
CREATE TABLE `x_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `log_id` varchar(30) DEFAULT NULL,
  `target_id` varchar(30) DEFAULT NULL,
  `log_type` varchar(8) DEFAULT NULL,
  `log_file_path` varchar(200) DEFAULT NULL,
  `start_time` varchar(25) DEFAULT NULL,
  `stop_time` varchar(25) DEFAULT NULL,
  `created_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `target_result` char(2) DEFAULT NULL,
  `log_text` longtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for x_log_warning
-- ----------------------------
DROP TABLE IF EXISTS `x_log_warning`;
CREATE TABLE `x_log_warning` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `log_id` varchar(50) DEFAULT NULL,
  `target_id` varchar(30) DEFAULT NULL,
  `target_name` varchar(200) DEFAULT NULL,
  `log_type` varchar(8) DEFAULT NULL,
  `log_file` varchar(200) DEFAULT NULL,
  `log_msg` text,
  `log_level` varchar(10) DEFAULT NULL,
  `log_error` varchar(10) DEFAULT NULL,
  `log_subject` varchar(20) DEFAULT NULL,
  `created_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for x_login_info
-- ----------------------------
DROP TABLE IF EXISTS `x_login_info`;
CREATE TABLE `x_login_info` (
  `user_name` varchar(50) DEFAULT '',
  `ipaddr` varchar(128) DEFAULT '',
  `login_location` varchar(255) DEFAULT '',
  `browser` varchar(50) DEFAULT '',
  `os` varchar(50) DEFAULT '',
  `status` char(4) DEFAULT '0',
  `msg` varchar(255) DEFAULT '',
  `login_time` datetime DEFAULT NULL,
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of x_login_info
-- ----------------------------
BEGIN;
INSERT INTO `x_login_info` VALUES ('superadmin', '127.0.0.1', '内网IP', 'Chrome 9', 'Mac OS X', '登录成功', '登录成功', '2021-12-09 15:15:23', 1);
INSERT INTO `x_login_info` VALUES ('superadmin', '127.0.0.1', '内网IP', 'Chrome 9', 'Mac OS X', '登录成功', '登录成功', '2021-12-10 09:20:36', 2);
INSERT INTO `x_login_info` VALUES ('superadmin', '127.0.0.1', '内网IP', 'Chrome 9', 'Mac OS X', '登录成功', '登录成功', '2021-12-10 14:17:31', 3);
INSERT INTO `x_login_info` VALUES ('superadmin', '127.0.0.1', '内网IP', 'Chrome 9', 'Mac OS X', '登录成功', '登录成功', '2021-12-13 13:59:11', 4);
INSERT INTO `x_login_info` VALUES ('superadmin', '127.0.0.1', '内网IP', 'Chrome 9', 'Mac OS X', '登录成功', '登录成功', '2021-12-13 14:52:44', 5);
INSERT INTO `x_login_info` VALUES ('superadmin', '127.0.0.1', '内网IP', 'Chrome 9', 'Mac OS X', '登录成功', '登录成功', '2021-12-13 15:57:51', 6);
INSERT INTO `x_login_info` VALUES ('superadmin', '127.0.0.1', '内网IP', 'Chrome 9', 'Mac OS X', '登录失败', '验证码错误', '2021-12-15 10:14:16', 7);
INSERT INTO `x_login_info` VALUES ('superadmin', '127.0.0.1', '内网IP', 'Chrome 9', 'Mac OS X', '登录成功', '登录成功', '2021-12-15 10:14:18', 8);
INSERT INTO `x_login_info` VALUES ('superadmin', '127.0.0.1', '内网IP', 'Chrome 9', 'Mac OS X', '登录成功', '登录成功', '2021-12-15 11:23:33', 9);
INSERT INTO `x_login_info` VALUES ('superadmin', '127.0.0.1', '内网IP', 'Chrome 9', 'Mac OS X', '登录成功', '登录成功', '2021-12-15 12:23:44', 10);
INSERT INTO `x_login_info` VALUES ('superadmin', '127.0.0.1', '内网IP', 'Chrome 9', 'Mac OS X', '登录成功', '登录成功', '2021-12-15 12:27:57', 11);
INSERT INTO `x_login_info` VALUES ('superadmin', '127.0.0.1', '内网IP', 'Chrome 9', 'Mac OS X', '登录成功', '登录成功', '2021-12-17 09:21:14', 12);
INSERT INTO `x_login_info` VALUES ('superadmin', '127.0.0.1', '内网IP', 'Chrome 9', 'Mac OS X', '登录成功', '登录成功', '2021-12-17 10:22:56', 13);
INSERT INTO `x_login_info` VALUES ('superadmin', '127.0.0.1', '内网IP', 'Chrome 9', 'Mac OS X', '登录成功', '登录成功', '2021-12-17 11:30:05', 14);
INSERT INTO `x_login_info` VALUES ('superadmin', '127.0.0.1', '内网IP', 'Chrome 9', 'Mac OS X', '登录成功', '登录成功', '2021-12-17 11:41:51', 15);
INSERT INTO `x_login_info` VALUES ('superadmin', '127.0.0.1', '内网IP', 'Chrome 9', 'Mac OS X', '登录成功', '登录成功', '2021-12-17 12:02:04', 16);
INSERT INTO `x_login_info` VALUES ('superadmin', '127.0.0.1', '内网IP', 'Chrome 9', 'Mac OS X', '登录成功', '登录成功', '2021-12-17 12:13:53', 17);
INSERT INTO `x_login_info` VALUES ('superadmin', '127.0.0.1', '内网IP', 'Chrome 9', 'Mac OS X', '登录成功', '登录成功', '2021-12-17 14:00:48', 18);
INSERT INTO `x_login_info` VALUES ('superadmin', '127.0.0.1', '内网IP', 'Chrome 9', 'Mac OS X', '登录成功', '登录成功', '2021-12-17 14:16:44', 19);
INSERT INTO `x_login_info` VALUES ('superadmin', '127.0.0.1', '内网IP', 'Chrome 9', 'Mac OS X', '登录成功', '登录成功', '2021-12-17 14:20:20', 20);
INSERT INTO `x_login_info` VALUES ('superadmin', '127.0.0.1', '内网IP', 'Chrome 9', 'Mac OS X', '登录成功', '登录成功', '2021-12-17 14:24:14', 21);
INSERT INTO `x_login_info` VALUES ('superadmin', '127.0.0.1', '内网IP', 'Chrome 9', 'Mac OS X', '登录成功', '登录成功', '2021-12-17 14:30:39', 22);
INSERT INTO `x_login_info` VALUES ('superadmin', '127.0.0.1', '内网IP', 'Chrome 9', 'Mac OS X', '登录成功', '登录成功', '2021-12-17 14:33:47', 23);
INSERT INTO `x_login_info` VALUES ('superadmin', '127.0.0.1', '内网IP', 'Chrome 9', 'Mac OS X', '登录成功', '登录成功', '2021-12-22 10:03:05', 24);
INSERT INTO `x_login_info` VALUES ('superadmin', '127.0.0.1', '内网IP', 'Chrome 9', 'Mac OS X', '登录成功', '登录成功', '2021-12-22 11:03:21', 25);
INSERT INTO `x_login_info` VALUES ('superadmin', '127.0.0.1', '内网IP', 'Chrome 9', 'Mac OS X', '登录失败', '验证码错误', '2021-12-22 12:10:53', 26);
INSERT INTO `x_login_info` VALUES ('superadmin', '127.0.0.1', '内网IP', 'Chrome 9', 'Mac OS X', '登录成功', '登录成功', '2021-12-22 12:10:56', 27);
INSERT INTO `x_login_info` VALUES ('superadmin', '127.0.0.1', '内网IP', 'Chrome 9', 'Mac OS X', '登录成功', '登录成功', '2021-12-22 12:34:37', 28);
INSERT INTO `x_login_info` VALUES ('superadmin', '127.0.0.1', '内网IP', 'Chrome 9', 'Mac OS X', '登录成功', '登录成功', '2021-12-22 13:08:06', 29);
INSERT INTO `x_login_info` VALUES ('superadmin', '127.0.0.1', '内网IP', 'Chrome 9', 'Mac OS X', '登录成功', '登录成功', '2021-12-22 14:44:11', 30);
COMMIT;

-- ----------------------------
-- Table structure for x_menu
-- ----------------------------
DROP TABLE IF EXISTS `x_menu`;
CREATE TABLE `x_menu` (
  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `menu_name` varchar(50) NOT NULL,
  `parent_id` bigint(20) DEFAULT '0',
  `order_num` int(4) DEFAULT '0',
  `path` varchar(200) DEFAULT '',
  `component` varchar(255) DEFAULT NULL,
  `is_frame` int(1) DEFAULT '1',
  `is_cache` int(1) DEFAULT '0',
  `menu_type` char(1) DEFAULT '',
  `visible` char(1) DEFAULT '0',
  `status` char(1) DEFAULT '0',
  `perms` varchar(100) DEFAULT NULL,
  `icon` varchar(100) DEFAULT '#',
  `create_by` varchar(64) DEFAULT '',
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(64) DEFAULT '',
  `update_time` datetime DEFAULT NULL,
  `remark` varchar(500) DEFAULT '',
  PRIMARY KEY (`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for x_monitor
-- ----------------------------
DROP TABLE IF EXISTS `x_monitor`;
CREATE TABLE `x_monitor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `monitor_id` varchar(30) NOT NULL,
  `target_id` varchar(100) DEFAULT NULL,
  `success_count` varchar(5) DEFAULT NULL,
  `fail_count` varchar(5) DEFAULT NULL,
  `target_status` char(2) DEFAULT NULL,
  `created_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `target_lines_read` varchar(10) DEFAULT NULL,
  `target_lines_written` varchar(10) DEFAULT NULL,
  `target_lines_updated` varchar(10) DEFAULT NULL,
  `target_lines_input` varchar(10) DEFAULT NULL,
  `target_lines_output` varchar(10) DEFAULT NULL,
  `target_lines_rejected` varchar(10) DEFAULT NULL,
  `description` varchar(500) DEFAULT NULL,
  `monitor_type` varchar(8) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for x_notice
-- ----------------------------
DROP TABLE IF EXISTS `x_notice`;
CREATE TABLE `x_notice` (
  `notice_id` int(4) NOT NULL AUTO_INCREMENT,
  `notice_title` varchar(50) NOT NULL,
  `notice_type` char(1) NOT NULL,
  `notice_content` longblob,
  `status` char(1) DEFAULT '0',
  `create_by` varchar(64) DEFAULT '',
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(64) DEFAULT '',
  `update_time` datetime DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`notice_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for x_oper_log
-- ----------------------------
DROP TABLE IF EXISTS `x_oper_log`;
CREATE TABLE `x_oper_log` (
  `method` varchar(100) DEFAULT '',
  `oper_url` varchar(255) DEFAULT '',
  `oper_ip` varchar(128) DEFAULT '',
  `oper_location` varchar(255) DEFAULT '',
  `oper_param` varchar(2000) DEFAULT '',
  `json_result` varchar(2000) DEFAULT '',
  `status` char(7) DEFAULT '0',
  `error_msg` varchar(2000) DEFAULT '',
  `oper_time` datetime DEFAULT NULL,
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `operator_name` varchar(50) DEFAULT '',
  `module_name` varchar(50) DEFAULT '',
  `request_type` varchar(10) DEFAULT '',
  `client_type` char(6) DEFAULT '0',
  `oper_user_name` varchar(50) DEFAULT '0',
  `oper_dept_name` varchar(50) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of x_oper_log
-- ----------------------------
BEGIN;
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XJobApiController.startJob()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xjob/startJob', '127.0.0.1', '内网IP', '88', '{\"code\":11000,\"data\":\"任务提交成功,当前队列中总共1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-10 14:20:07', 1, 'START', '作业调度-启动作业', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XRepositoryController.updateRepository()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xrepository/update', '127.0.0.1', '内网IP', '{\"repoId\":\"1326379690046259200\",\"dbAccess\":\"Native\",\"repoName\":\"临时资源库\",\"dbName\":\"kettle\",\"dbHost\":\"192.168.3.166\",\"repoPassword\":\"admin\",\"type\":\"db\",\"repoUsername\":\"admin\",\"baseDir\":\"\",\"dbPort\":\"3306\",\"dbUsername\":\"root\",\"repoType\":\"MYSQL\",\"isDel\":\"0\",\"dbPassword\":\"root\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-13 14:51:30', 2, 'UPDATE', '资源库管理-更新资源库', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XParamsController.addParams()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xparams/add', '127.0.0.1', '内网IP', '{\"targetId\":\"117\",\"targetType\":\"job\",\"datas\":\"[{\\\"id\\\":8,\\\"objCode\\\":\\\"org_id\\\",\\\"objVal\\\":\\\"5\\\",\\\"objName\\\":\\\"\\\",\\\"objDes\\\":\\\"\\\",\\\"targetId\\\":\\\"117\\\",\\\"targetType\\\":\\\"job\\\",\\\"isUse\\\":\\\"1\\\",\\\"createdTime\\\":1639379847000,\\\"updateTime\\\":1639379847000}]\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-13 15:58:06', 3, 'INSERT', '参数管理-新增参数', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XJobApiController.startJob()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xjob/startJob', '127.0.0.1', '内网IP', '117', '{\"code\":11000,\"data\":\"任务提交成功,当前队列中总共1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-15 10:15:12', 4, 'START', '作业调度-启动作业', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XJobApiController.startJob()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xjob/startJob', '127.0.0.1', '内网IP', '117', '{\"code\":11000,\"data\":\"任务提交成功,当前队列中总共1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-15 10:17:21', 5, 'START', '作业调度-启动作业', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XJobApiController.startJob()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xjob/startJob', '127.0.0.1', '内网IP', '117', '{\"code\":11000,\"data\":\"任务提交成功,当前队列中总共1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-15 10:17:55', 6, 'START', '作业调度-启动作业', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XJobApiController.startJob()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xjob/startJob', '127.0.0.1', '内网IP', '117', '{\"code\":11000,\"data\":\"任务提交成功,当前队列中总共1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-15 10:22:06', 7, 'START', '作业调度-启动作业', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XJobController.delFromLocal()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xjob/delFromLocal', '127.0.0.1', '内网IP', '117', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-15 10:24:53', 8, 'DELETE', '作业管理-本地删除', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XJobController.addJob()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xjob/add', '127.0.0.1', '内网IP', '{\"jobName\":\"main\",\"tplKey\":\"\",\"jobPath\":\"/重庆仁品\",\"jobId\":\"117\",\"jobLogLevel\":\"detail\",\"jobRepositoryId\":\"1326379690046259200\",\"jobDescription\":\"重庆仁品\",\"id\":29,\"jobType\":\"db\",\"isDel\":\"0\",\"isMonitorEnabled\":\"1\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-15 10:25:22', 9, 'INSERT', '作业管理-新增', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XJobApiController.startJob()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xjob/startJob', '127.0.0.1', '内网IP', '117', '{\"code\":11000,\"data\":\"任务提交成功,当前队列中总共1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-15 10:25:29', 10, 'START', '作业调度-启动作业', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XJobApiController.startJob()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xjob/startJob', '127.0.0.1', '内网IP', '117', '{\"code\":11000,\"data\":\"任务提交成功,当前队列中总共1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-15 10:26:48', 11, 'START', '作业调度-启动作业', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XJobApiController.startJob()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xjob/startJob', '127.0.0.1', '内网IP', '117', '{\"code\":11000,\"data\":\"任务提交成功,当前队列中总共1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-15 10:27:19', 12, 'START', '作业调度-启动作业', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XJobApiController.startJob()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xjob/startJob', '127.0.0.1', '内网IP', '117', '{\"code\":11000,\"data\":\"任务提交成功,当前队列中总共1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-15 10:27:49', 13, 'START', '作业调度-启动作业', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XJobApiController.startJob()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xjob/startJob', '127.0.0.1', '内网IP', '117', '{\"code\":11000,\"data\":\"任务提交成功,当前队列中总共1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-15 10:30:40', 14, 'START', '作业调度-启动作业', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XJobApiController.startJob()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xjob/startJob', '127.0.0.1', '内网IP', '117', '{\"code\":11000,\"data\":\"任务提交成功,当前队列中总共1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-15 12:23:54', 15, 'START', '作业调度-启动作业', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XJobApiController.startJob()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xjob/startJob', '127.0.0.1', '内网IP', '117', '{\"code\":11000,\"data\":\"任务提交成功,当前队列中总共1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-15 12:28:16', 16, 'START', '作业调度-启动作业', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XJobController.updateJob()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xjob/update', '127.0.0.1', '内网IP', '{\"id\":29,\"jobId\":\"117\",\"jobName\":\"main\",\"jobDescription\":\"重庆仁品\",\"jobType\":\"db\",\"jobPath\":\"/重庆仁品\",\"jobRepositoryId\":\"1326379690046259200\",\"jobLogLevel\":\"error\",\"isDel\":0,\"tplKey\":\"\",\"isMonitorEnabled\":true}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-15 12:30:19', 17, 'UPDATE', '作业管理-更新', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XJobApiController.startJob()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xjob/startJob', '127.0.0.1', '内网IP', '117', '{\"code\":11000,\"data\":\"任务提交成功,当前队列中总共1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-15 12:30:21', 18, 'START', '作业调度-启动作业', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XJobApiController.startJob()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xjob/startJob', '127.0.0.1', '内网IP', '117', '{\"code\":11000,\"data\":\"任务提交成功,当前队列中总共1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-15 12:31:16', 19, 'START', '作业调度-启动作业', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XTransController.addTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xtrans/add', '127.0.0.1', '内网IP', '{\"transName\":\"test\",\"transDescription\":\"test\",\"transId\":\"10\",\"transRepositoryId\":\"1326379690046259200\",\"transType\":\"db\",\"transLogLevel\":\"minimal\",\"transPath\":\"/重庆仁品\",\"id\":4,\"isDel\":\"0\",\"isMonitorEnabled\":\"1\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 09:25:19', 20, 'INSERT', '转换管理-新增转换', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XParamsController.addParams()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xparams/add', '127.0.0.1', '内网IP', '{\"targetId\":\"3\",\"targetType\":\"trans\",\"datas\":\"[{\\\"objDes\\\":\\\"\\\",\\\"objCode\\\":\\\"org_id\\\",\\\"objName\\\":\\\"\\\",\\\"objVal\\\":\\\"5\\\"}]\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 10:29:06', 21, 'INSERT', '参数管理-新增参数', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XParamsController.addParams()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xparams/add', '127.0.0.1', '内网IP', '{\"targetId\":\"3\",\"targetType\":\"trans\",\"datas\":\"[{\\\"id\\\":12,\\\"objCode\\\":\\\"org_id\\\",\\\"objName\\\":\\\"\\\",\\\"objDes\\\":\\\"\\\",\\\"targetId\\\":\\\"3\\\",\\\"targetType\\\":\\\"trans\\\",\\\"isUse\\\":\\\"1\\\",\\\"createdTime\\\":1639708146000,\\\"updateTime\\\":1639708146000,\\\"objVal\\\":\\\"55\\\"}]\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 10:31:57', 22, 'INSERT', '参数管理-新增参数', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XParamsController.addParams()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xparams/add', '127.0.0.1', '内网IP', '{\"targetId\":\"10\",\"targetType\":\"trans\",\"datas\":\"[{\\\"objDes\\\":\\\"\\\",\\\"objCode\\\":\\\"org_id\\\",\\\"objName\\\":\\\"\\\",\\\"objVal\\\":\\\"哈哈\\\"}]\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 10:32:16', 23, 'INSERT', '参数管理-新增参数', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 11:30:42', 24, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XParamsController.addParams()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xparams/add', '127.0.0.1', '内网IP', '{\"targetId\":\"10\",\"targetType\":\"trans\",\"datas\":\"[{\\\"id\\\":14,\\\"objCode\\\":\\\"org_id\\\",\\\"objName\\\":\\\"\\\",\\\"objDes\\\":\\\"\\\",\\\"targetId\\\":\\\"10\\\",\\\"targetType\\\":\\\"trans\\\",\\\"isUse\\\":\\\"1\\\",\\\"createdTime\\\":1639708336000,\\\"updateTime\\\":1639708336000,\\\"objVal\\\":\\\"5\\\"}]\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 11:42:33', 25, 'INSERT', '参数管理-新增参数', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XTransController.delFromLocal()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xtrans/delFromLocal', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 11:42:38', 26, 'DELETE', '转换管理-本地删除', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XTransController.addTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xtrans/add', '127.0.0.1', '内网IP', '{\"transName\":\"test\",\"transDescription\":\"test\",\"transId\":\"10\",\"transRepositoryId\":\"1326379690046259200\",\"transType\":\"db\",\"transLogLevel\":\"error\",\"transPath\":\"/重庆仁品\",\"id\":5,\"isDel\":\"0\",\"isMonitorEnabled\":\"1\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 11:43:12', 27, 'INSERT', '转换管理-新增转换', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XParamsController.addParams()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xparams/add', '127.0.0.1', '内网IP', '{\"targetId\":\"10\",\"targetType\":\"trans\",\"datas\":\"[{\\\"id\\\":15,\\\"objCode\\\":\\\"org_id\\\",\\\"objVal\\\":\\\"5\\\",\\\"objName\\\":\\\"\\\",\\\"objDes\\\":\\\"\\\",\\\"targetId\\\":\\\"10\\\",\\\"targetType\\\":\\\"trans\\\",\\\"isUse\\\":\\\"1\\\",\\\"createdTime\\\":1639712553000,\\\"updateTime\\\":1639712553000}]\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 11:43:16', 28, 'INSERT', '参数管理-新增参数', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XParamsController.addParams()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xparams/add', '127.0.0.1', '内网IP', '{\"targetId\":\"10\",\"targetType\":\"trans\",\"datas\":\"[{\\\"id\\\":16,\\\"objCode\\\":\\\"org_id\\\",\\\"objVal\\\":\\\"5\\\",\\\"objName\\\":\\\"\\\",\\\"objDes\\\":\\\"\\\",\\\"targetId\\\":\\\"10\\\",\\\"targetType\\\":\\\"trans\\\",\\\"isUse\\\":\\\"1\\\",\\\"createdTime\\\":1639712596000,\\\"updateTime\\\":1639712596000}]\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 11:43:26', 29, 'INSERT', '参数管理-新增参数', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 11:43:30', 30, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XTransController.updateTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xtrans/update', '127.0.0.1', '内网IP', '{\"transName\":\"table2updateTpl\",\"transDescription\":\"数据表同步\",\"transId\":\"5\",\"transRepositoryId\":\"1326379690046259200\",\"transType\":\"db\",\"transLogLevel\":\"detail\",\"transPath\":\"/common\",\"id\":3,\"isDel\":\"0\",\"isMonitorEnabled\":\"1\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 11:44:04', 31, 'UPDATE', '转换管理-更新转换', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 11:44:21', 32, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 11:45:00', 33, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 11:45:25', 34, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 11:46:57', 35, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.killTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/killTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"转换终止成功,状态:已结束\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 11:47:22', 36, 'STOP', '转换调度-终止转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 11:48:29', 37, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XTransController.updateTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xtrans/update', '127.0.0.1', '内网IP', '{\"transName\":\"test\",\"transDescription\":\"test\",\"transId\":\"10\",\"transRepositoryId\":\"1326379690046259200\",\"transType\":\"db\",\"transLogLevel\":\"detail\",\"transPath\":\"/重庆仁品\",\"id\":5,\"isDel\":\"0\",\"isMonitorEnabled\":\"1\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 11:48:45', 38, 'UPDATE', '转换管理-更新转换', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 11:48:48', 39, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XParamsController.addParams()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xparams/add', '127.0.0.1', '内网IP', '{\"targetId\":\"10\",\"targetType\":\"trans\",\"datas\":\"[{\\\"id\\\":17,\\\"objCode\\\":\\\"org_id\\\",\\\"objName\\\":\\\"\\\",\\\"objDes\\\":\\\"\\\",\\\"targetId\\\":\\\"10\\\",\\\"targetType\\\":\\\"trans\\\",\\\"isUse\\\":\\\"1\\\",\\\"createdTime\\\":1639712606000,\\\"updateTime\\\":1639712606000,\\\"objVal\\\":\\\"2\\\"}]\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 11:49:11', 40, 'INSERT', '参数管理-新增参数', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 11:49:13', 41, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 11:53:02', 42, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XParamsController.addParams()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xparams/add', '127.0.0.1', '内网IP', '{\"targetId\":\"10\",\"targetType\":\"trans\",\"datas\":\"[{\\\"id\\\":18,\\\"objCode\\\":\\\"org_id\\\",\\\"objVal\\\":\\\"2\\\",\\\"objName\\\":\\\"\\\",\\\"objDes\\\":\\\"\\\",\\\"targetId\\\":\\\"10\\\",\\\"targetType\\\":\\\"trans\\\",\\\"isUse\\\":\\\"1\\\",\\\"createdTime\\\":1639712951000,\\\"updateTime\\\":1639712951000}]\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 11:53:48', 43, 'INSERT', '参数管理-新增参数', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XLogController.deleteLog()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xlog/delete', '127.0.0.1', '内网IP', '1471689987064856576,1471689026757984256,1471688920121999360,1471687587079913472', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 11:54:04', 44, 'DELETE', '日志管理-清理日志', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 11:54:13', 45, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 11:55:16', 46, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 11:57:52', 47, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:02:50', 48, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XParamsController.addParams()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xparams/add', '127.0.0.1', '内网IP', '{\"targetId\":\"10\",\"targetType\":\"trans\",\"datas\":\"[{\\\"id\\\":19,\\\"objCode\\\":\\\"org_id\\\",\\\"objName\\\":\\\"\\\",\\\"objDes\\\":\\\"\\\",\\\"targetId\\\":\\\"10\\\",\\\"targetType\\\":\\\"trans\\\",\\\"isUse\\\":\\\"1\\\",\\\"createdTime\\\":1639713228000,\\\"updateTime\\\":1639713228000,\\\"objVal\\\":\\\"1\\\"}]\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:03:12', 49, 'INSERT', '参数管理-新增参数', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XParamsController.addParams()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xparams/add', '127.0.0.1', '内网IP', '{\"targetId\":\"10\",\"targetType\":\"trans\",\"datas\":\"[{\\\"id\\\":20,\\\"objCode\\\":\\\"org_id\\\",\\\"objName\\\":\\\"\\\",\\\"objDes\\\":\\\"\\\",\\\"targetId\\\":\\\"10\\\",\\\"targetType\\\":\\\"trans\\\",\\\"isUse\\\":\\\"1\\\",\\\"createdTime\\\":1639713792000,\\\"updateTime\\\":1639713792000,\\\"objVal\\\":\\\"1\\\"}]\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:04:43', 50, 'INSERT', '参数管理-新增参数', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:04:46', 51, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XParamsController.addParams()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xparams/add', '127.0.0.1', '内网IP', '{\"targetId\":\"10\",\"targetType\":\"trans\",\"datas\":\"[{\\\"id\\\":21,\\\"objCode\\\":\\\"org_id\\\",\\\"objName\\\":\\\"\\\",\\\"objDes\\\":\\\"\\\",\\\"targetId\\\":\\\"10\\\",\\\"targetType\\\":\\\"trans\\\",\\\"isUse\\\":\\\"1\\\",\\\"createdTime\\\":1639713883000,\\\"updateTime\\\":1639713883000,\\\"objVal\\\":\\\"5\\\"}]\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:05:16', 52, 'INSERT', '参数管理-新增参数', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:05:18', 53, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XTransController.updateTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xtrans/update', '127.0.0.1', '内网IP', '{\"transName\":\"test\",\"transDescription\":\"test\",\"transId\":\"10\",\"transRepositoryId\":\"1326379690046259200\",\"transType\":\"db\",\"transLogLevel\":\"error\",\"transPath\":\"/重庆仁品\",\"id\":5,\"isDel\":\"0\",\"isMonitorEnabled\":\"1\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:05:50', 54, 'UPDATE', '转换管理-更新转换', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:05:52', 55, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XTransController.updateTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xtrans/update', '127.0.0.1', '内网IP', '{\"transName\":\"test\",\"transDescription\":\"test\",\"transId\":\"10\",\"transRepositoryId\":\"1326379690046259200\",\"transType\":\"db\",\"transLogLevel\":\"debug\",\"transPath\":\"/重庆仁品\",\"id\":5,\"isDel\":\"0\",\"isMonitorEnabled\":\"1\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:06:30', 56, 'UPDATE', '转换管理-更新转换', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:06:32', 57, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XTransController.updateTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xtrans/update', '127.0.0.1', '内网IP', '{\"transName\":\"test\",\"transDescription\":\"test\",\"transId\":\"10\",\"transRepositoryId\":\"1326379690046259200\",\"transType\":\"db\",\"transLogLevel\":\"basic\",\"transPath\":\"/重庆仁品\",\"id\":5,\"isDel\":\"0\",\"isMonitorEnabled\":\"1\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:06:52', 58, 'UPDATE', '转换管理-更新转换', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:06:54', 59, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:07:20', 60, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XTransController.updateTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xtrans/update', '127.0.0.1', '内网IP', '{\"transName\":\"test\",\"transDescription\":\"test\",\"transId\":\"10\",\"transRepositoryId\":\"1326379690046259200\",\"transType\":\"db\",\"transLogLevel\":\"detail\",\"transPath\":\"/重庆仁品\",\"id\":5,\"isDel\":\"0\",\"isMonitorEnabled\":\"1\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:07:35', 61, 'UPDATE', '转换管理-更新转换', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:07:37', 62, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XTransController.updateTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xtrans/update', '127.0.0.1', '内网IP', '{\"transName\":\"test\",\"transDescription\":\"test\",\"transId\":\"10\",\"transRepositoryId\":\"1326379690046259200\",\"transType\":\"db\",\"transLogLevel\":\"error\",\"transPath\":\"/重庆仁品\",\"id\":5,\"isDel\":\"0\",\"isMonitorEnabled\":\"1\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:07:47', 63, 'UPDATE', '转换管理-更新转换', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:07:53', 64, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:08:00', 65, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XTransController.updateTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xtrans/update', '127.0.0.1', '内网IP', '{\"transName\":\"test\",\"transDescription\":\"test\",\"transId\":\"10\",\"transRepositoryId\":\"1326379690046259200\",\"transType\":\"db\",\"transLogLevel\":\"debug\",\"transPath\":\"/重庆仁品\",\"id\":5,\"isDel\":\"0\",\"isMonitorEnabled\":\"1\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:08:13', 66, 'UPDATE', '转换管理-更新转换', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:08:15', 67, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XTransController.updateTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xtrans/update', '127.0.0.1', '内网IP', '{\"transName\":\"test\",\"transDescription\":\"test\",\"transId\":\"10\",\"transRepositoryId\":\"1326379690046259200\",\"transType\":\"db\",\"transLogLevel\":\"minimal\",\"transPath\":\"/重庆仁品\",\"id\":5,\"isDel\":\"0\",\"isMonitorEnabled\":\"1\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:08:23', 68, 'UPDATE', '转换管理-更新转换', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XTransController.updateTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xtrans/update', '127.0.0.1', '内网IP', '{\"transName\":\"test\",\"transDescription\":\"test\",\"transId\":\"10\",\"transRepositoryId\":\"1326379690046259200\",\"transType\":\"db\",\"transLogLevel\":\"minimal\",\"transPath\":\"/重庆仁品\",\"id\":5,\"isDel\":\"0\",\"isMonitorEnabled\":\"1\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:08:40', 69, 'UPDATE', '转换管理-更新转换', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:08:44', 70, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XTransController.updateTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xtrans/update', '127.0.0.1', '内网IP', '{\"transName\":\"test\",\"transDescription\":\"test\",\"transId\":\"10\",\"transRepositoryId\":\"1326379690046259200\",\"transType\":\"db\",\"transLogLevel\":\"rowlevel\",\"transPath\":\"/重庆仁品\",\"id\":5,\"isDel\":\"0\",\"isMonitorEnabled\":\"1\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:08:59', 71, 'UPDATE', '转换管理-更新转换', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:09:01', 72, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XTransController.updateTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xtrans/update', '127.0.0.1', '内网IP', '{\"transName\":\"test\",\"transDescription\":\"test\",\"transId\":\"10\",\"transRepositoryId\":\"1326379690046259200\",\"transType\":\"db\",\"transLogLevel\":\"minimal\",\"transPath\":\"/重庆仁品\",\"id\":5,\"isDel\":\"0\",\"isMonitorEnabled\":\"1\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:09:30', 73, 'UPDATE', '转换管理-更新转换', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:09:34', 74, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XTransController.updateTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xtrans/update', '127.0.0.1', '内网IP', '{\"transName\":\"test\",\"transDescription\":\"test\",\"transId\":\"10\",\"transRepositoryId\":\"1326379690046259200\",\"transType\":\"db\",\"transLogLevel\":\"Nothing\",\"transPath\":\"/重庆仁品\",\"id\":5,\"isDel\":\"0\",\"isMonitorEnabled\":\"1\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:09:43', 75, 'UPDATE', '转换管理-更新转换', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:09:48', 76, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:11:05', 77, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:11:19', 78, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:14:13', 79, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XTransController.updateTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xtrans/update', '127.0.0.1', '内网IP', '{\"transName\":\"test\",\"transDescription\":\"test\",\"transId\":\"10\",\"transRepositoryId\":\"1326379690046259200\",\"transType\":\"db\",\"transLogLevel\":\"basic\",\"transPath\":\"/重庆仁品\",\"id\":5,\"isDel\":\"0\",\"isMonitorEnabled\":\"1\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:14:22', 80, 'UPDATE', '转换管理-更新转换', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:14:24', 81, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.killTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/killTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"转换终止成功,状态:已结束\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:15:57', 82, 'STOP', '转换调度-终止转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.addTrans2Sche()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/addTrans2Sche', '127.0.0.1', '内网IP', '10 0 0/1 * * * ? 放到', '{\"code\":11000,\"data\":\"任务添加定时队列成功!\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:19:25', 83, 'SCHEDULER', '转换调度-定时', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XParamsController.addParams()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xparams/add', '127.0.0.1', '内网IP', '{\"targetId\":\"10\",\"targetType\":\"trans\",\"datas\":\"[{\\\"id\\\":22,\\\"objCode\\\":\\\"org_id\\\",\\\"objName\\\":\\\"\\\",\\\"objDes\\\":\\\"\\\",\\\"targetId\\\":\\\"10\\\",\\\"targetType\\\":\\\"trans\\\",\\\"isUse\\\":\\\"1\\\",\\\"createdTime\\\":1639713916000,\\\"updateTime\\\":1639713916000,\\\"objVal\\\":\\\"2\\\"}]\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:25:45', 84, 'INSERT', '参数管理-新增参数', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XQuartzController.updateQuartz()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xquartz/updScheStatus', '127.0.0.1', '内网IP', '1471695672662032384 1', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 12:29:14', 85, 'UPDATE', '定时管理-切换定时开关', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 14:16:51', 86, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 14:17:11', 87, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 14:24:20', 88, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 14:30:46', 89, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 14:32:01', 90, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 14:32:35', 91, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 14:33:57', 92, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 14:34:40', 93, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 14:35:36', 94, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 14:39:20', 95, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.kettle.api.XTransApiController.startTrans()', '/xtl-serverhttp://localhost:9876/xtl-server/api/xtrans/startTrans', '127.0.0.1', '内网IP', '10', '{\"code\":11000,\"data\":\"任务提交成功,队列中总共有1个任务\",\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-17 14:40:43', 96, 'START', '转换调度-启动转换', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.log.LoggingController.deleteOperLog()', '/xtl-serverhttp://localhost:9876/xtl-server/log/deleteOperLog', '127.0.0.1', '内网IP', '139', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-22 11:35:23', 140, 'DELETE', '日志监控-清理操作日志', 'GET', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XJobController.addJob()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xjob/add', '127.0.0.1', '内网IP', '{\"jobName\":\"main\",\"tplKey\":\"\",\"jobPath\":\"/仁品数据同步\",\"jobId\":\"117\",\"jobLogLevel\":\"basic\",\"jobRepositoryId\":\"1326379690046259200\",\"jobDescription\":\"仁品\",\"id\":31,\"jobType\":\"db\",\"isDel\":\"0\",\"isMonitorEnabled\":\"1\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-22 11:37:02', 141, 'INSERT', '作业管理-新增', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XParamsController.addParams()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xparams/add', '127.0.0.1', '内网IP', '{\"targetId\":\"117\",\"targetType\":\"job\",\"datas\":\"[{\\\"id\\\":75,\\\"objCode\\\":\\\"org_id\\\",\\\"objVal\\\":\\\"5\\\",\\\"objName\\\":\\\"\\\",\\\"objDes\\\":\\\"\\\",\\\"targetId\\\":\\\"117\\\",\\\"targetType\\\":\\\"job\\\",\\\"isUse\\\":\\\"1\\\",\\\"createdTime\\\":1640141646000,\\\"updateTime\\\":1640141646000},{\\\"id\\\":76,\\\"objCode\\\":\\\"begin_date\\\",\\\"objVal\\\":\\\"${YESTERDAY_BEGIN}\\\",\\\"objName\\\":\\\"\\\",\\\"objDes\\\":\\\"\\\",\\\"targetId\\\":\\\"117\\\",\\\"targetType\\\":\\\"job\\\",\\\"isUse\\\":\\\"1\\\",\\\"createdTime\\\":1640141646000,\\\"updateTime\\\":1640141646000},{\\\"id\\\":77,\\\"objCode\\\":\\\"end_date\\\",\\\"objVal\\\":\\\"${YESTERDAY_END}\\\",\\\"objName\\\":\\\"\\\",\\\"objDes\\\":\\\"\\\",\\\"targetId\\\":\\\"117\\\",\\\"targetType\\\":\\\"job\\\",\\\"isUse\\\":\\\"1\\\",\\\"createdTime\\\":1640141646000,\\\"updateTime\\\":1640141646000},{\\\"id\\\":78,\\\"objCode\\\":\\\"his_ip\\\",\\\"objVal\\\":\\\"222.199.199.11\\\",\\\"objName\\\":\\\"\\\",\\\"objDes\\\":\\\"\\\",\\\"targetId\\\":\\\"117\\\",\\\"targetType\\\":\\\"job\\\",\\\"isUse\\\":\\\"1\\\",\\\"createdTime\\\":1640141646000,\\\"updateTime\\\":1640141646000},{\\\"id\\\":79,\\\"objCode\\\":\\\"his_password\\\",\\\"objVal\\\":\\\"XXYadmin123\\\",\\\"objName\\\":\\\"\\\",\\\"objDes\\\":\\\"\\\",\\\"targetId\\\":\\\"117\\\",\\\"targetType\\\":\\\"job\\\",\\\"isUse\\\":\\\"1\\\",\\\"createdTime\\\":1640141646000,\\\"updateTime\\\":1640141646000}]\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-22 11:37:11', 142, 'INSERT', '参数管理-新增参数', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XJobController.updateJob()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xjob/update', '127.0.0.1', '内网IP', '{\"id\":31,\"jobId\":\"117\",\"jobName\":\"main\",\"jobDescription\":\"重庆仁品\",\"jobType\":\"db\",\"jobPath\":\"/仁品数据同步\",\"jobRepositoryId\":\"1326379690046259200\",\"jobLogLevel\":\"basic\",\"isDel\":0,\"tplKey\":\"\",\"isMonitorEnabled\":true}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-22 11:37:21', 143, 'UPDATE', '作业管理-更新', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
INSERT INTO `x_oper_log` VALUES ('org.yaukie.frame.autocode.controller.XParamsController.addParams()', '/xtl-serverhttp://localhost:9876/xtl-server/op/xparams/add', '127.0.0.1', '内网IP', '{\"targetId\":\"117\",\"targetType\":\"job\",\"datas\":\"[{\\\"id\\\":80,\\\"objCode\\\":\\\"org_id\\\",\\\"objName\\\":\\\"\\\",\\\"objDes\\\":\\\"\\\",\\\"targetId\\\":\\\"117\\\",\\\"targetType\\\":\\\"job\\\",\\\"isUse\\\":\\\"1\\\",\\\"createdTime\\\":1640144231000,\\\"updateTime\\\":1640144231000,\\\"objVal\\\":\\\"5\\\"},{\\\"id\\\":81,\\\"objCode\\\":\\\"begin_date\\\",\\\"objName\\\":\\\"\\\",\\\"objDes\\\":\\\"\\\",\\\"targetId\\\":\\\"117\\\",\\\"targetType\\\":\\\"job\\\",\\\"isUse\\\":\\\"1\\\",\\\"createdTime\\\":1640144231000,\\\"updateTime\\\":1640144231000,\\\"objVal\\\":\\\"${YESTERDAY_BEGIN}\\\"},{\\\"id\\\":82,\\\"objCode\\\":\\\"end_date\\\",\\\"objName\\\":\\\"\\\",\\\"objDes\\\":\\\"\\\",\\\"targetId\\\":\\\"117\\\",\\\"targetType\\\":\\\"job\\\",\\\"isUse\\\":\\\"1\\\",\\\"createdTime\\\":1640144231000,\\\"updateTime\\\":1640144231000,\\\"objVal\\\":\\\"${YESTERDAY_END}\\\"},{\\\"id\\\":83,\\\"objCode\\\":\\\"his_ip\\\",\\\"objName\\\":\\\"\\\",\\\"objDes\\\":\\\"\\\",\\\"targetId\\\":\\\"117\\\",\\\"targetType\\\":\\\"job\\\",\\\"isUse\\\":\\\"1\\\",\\\"createdTime\\\":1640144231000,\\\"updateTime\\\":1640144231000,\\\"objVal\\\":\\\"222.199.199.11\\\"},{\\\"id\\\":84,\\\"objCode\\\":\\\"his_password\\\",\\\"objName\\\":\\\"\\\",\\\"objDes\\\":\\\"\\\",\\\"targetId\\\":\\\"117\\\",\\\"targetType\\\":\\\"job\\\",\\\"isUse\\\":\\\"1\\\",\\\"createdTime\\\":1640144231000,\\\"updateTime\\\":1640144231000,\\\"objVal\\\":\\\"XXYadmin123\\\"}]\"}', '{\"code\":11000,\"msg\":\"请求成功\",\"success\":true}', 'SUCCESS', NULL, '2021-12-22 11:37:31', 144, 'INSERT', '参数管理-新增参数', 'POST', 'PC', 'superadmin', 'SmartKettle-演示部门');
COMMIT;

-- ----------------------------
-- Table structure for x_params
-- ----------------------------
DROP TABLE IF EXISTS `x_params`;
CREATE TABLE `x_params` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `obj_code` varchar(30) DEFAULT NULL,
  `obj_name` varchar(30) DEFAULT NULL,
  `obj_des` varchar(30) DEFAULT NULL,
  `target_id` varchar(30) DEFAULT NULL,
  `target_type` varchar(8) DEFAULT NULL,
  `is_use` char(2) DEFAULT NULL,
  `created_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `obj_val` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of x_params
-- ----------------------------
BEGIN;
INSERT INTO `x_params` VALUES (4, 'category1_id', '', '', '88', 'job', '1', '2021-12-10 14:26:33', '2021-12-10 14:26:33', '1');
INSERT INTO `x_params` VALUES (7, 'org_id', '', '', '114', 'job', '1', '2021-12-13 15:15:26', '2021-12-13 15:15:26', '5');
INSERT INTO `x_params` VALUES (13, 'org_id', '', '', '3', 'trans', '1', '2021-12-17 10:31:57', '2021-12-17 10:31:57', '55');
INSERT INTO `x_params` VALUES (32, 'org_id', '', '', '10', 'trans', '1', '2021-12-17 14:09:43', '2021-12-17 14:09:43', '1');
INSERT INTO `x_params` VALUES (33, 'USER_ID', '', '', '10', 'trans', '1', '2021-12-17 14:09:43', '2021-12-17 14:09:43', '${USER_ID}');
INSERT INTO `x_params` VALUES (34, 'NOW_DATE', '', '', '10', 'trans', '1', '2021-12-17 14:09:43', '2021-12-17 14:09:43', '${NOW_DATE}');
INSERT INTO `x_params` VALUES (35, 'NOW_TIME', '', '', '10', 'trans', '1', '2021-12-17 14:09:43', '2021-12-17 14:09:43', '${NOW_TIME}');
INSERT INTO `x_params` VALUES (36, 'TODAY_BEGIN', '', '', '10', 'trans', '1', '2021-12-17 14:09:43', '2021-12-17 14:09:43', '${TODAY_BEGIN}');
INSERT INTO `x_params` VALUES (37, 'TODAY_END', '', '', '10', 'trans', '1', '2021-12-17 14:09:43', '2021-12-17 14:09:43', '${TODAY_END}');
INSERT INTO `x_params` VALUES (38, 'YESTERDAY_BEGIN', '', '', '10', 'trans', '1', '2021-12-17 14:09:43', '2021-12-17 14:09:43', '${YESTERDAY_BEGIN}');
INSERT INTO `x_params` VALUES (39, 'YESTERDAY_END', '', '', '10', 'trans', '1', '2021-12-17 14:09:43', '2021-12-17 14:09:43', '${YESTERDAY_END}');
INSERT INTO `x_params` VALUES (65, 'org_id', '', '', '118', 'job', '1', '2021-12-22 10:51:22', '2021-12-22 10:51:22', '5');
INSERT INTO `x_params` VALUES (66, 'begin_date', '', '', '118', 'job', '1', '2021-12-22 10:51:22', '2021-12-22 10:51:22', '${YESTERDAY_BEGIN}');
INSERT INTO `x_params` VALUES (67, 'end_date', '', '', '118', 'job', '1', '2021-12-22 10:51:22', '2021-12-22 10:51:22', '{YESTERDAY_END}');
INSERT INTO `x_params` VALUES (68, 'his_ip', '', '', '118', 'job', '1', '2021-12-22 10:51:22', '2021-12-22 10:51:22', '222.199.199.11');
INSERT INTO `x_params` VALUES (69, 'his_password', '', '', '118', 'job', '1', '2021-12-22 10:51:22', '2021-12-22 10:51:22', 'XXYadmin123');
INSERT INTO `x_params` VALUES (85, 'org_id', '', '', '117', 'job', '1', '2021-12-22 11:37:31', '2021-12-22 11:37:31', '5');
INSERT INTO `x_params` VALUES (86, 'begin_date', '', '', '117', 'job', '1', '2021-12-22 11:37:31', '2021-12-22 11:37:31', '${YESTERDAY_BEGIN}');
INSERT INTO `x_params` VALUES (87, 'end_date', '', '', '117', 'job', '1', '2021-12-22 11:37:31', '2021-12-22 11:37:31', '${YESTERDAY_END}');
INSERT INTO `x_params` VALUES (88, 'his_ip', '', '', '117', 'job', '1', '2021-12-22 11:37:31', '2021-12-22 11:37:31', '222.199.199.11');
INSERT INTO `x_params` VALUES (89, 'his_password', '', '', '117', 'job', '1', '2021-12-22 11:37:31', '2021-12-22 11:37:31', 'XXYadmin123');
COMMIT;

-- ----------------------------
-- Table structure for x_post
-- ----------------------------
DROP TABLE IF EXISTS `x_post`;
CREATE TABLE `x_post` (
  `post_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `post_code` varchar(64) NOT NULL,
  `post_name` varchar(50) NOT NULL,
  `post_sort` int(4) NOT NULL,
  `status` char(1) NOT NULL,
  `create_by` varchar(64) DEFAULT '',
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(64) DEFAULT '',
  `update_time` datetime DEFAULT NULL,
  `remark` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`post_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for x_quartz
-- ----------------------------
DROP TABLE IF EXISTS `x_quartz`;
CREATE TABLE `x_quartz` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `quartz_id` varchar(30) NOT NULL,
  `quartz_description` varchar(500) DEFAULT NULL,
  `quartz_cron` varchar(100) DEFAULT NULL,
  `is_del` char(2) DEFAULT NULL,
  `created_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `target_id` varchar(30) NOT NULL,
  `quartz_type` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of x_quartz
-- ----------------------------
BEGIN;
INSERT INTO `x_quartz` VALUES (1, '1471695672662032384', '放到', '0 0/1 * * * ?', '1', '2021-12-17 12:15:38', '2021-12-17 12:15:38', '10', 'trans');
COMMIT;

-- ----------------------------
-- Table structure for x_repository
-- ----------------------------
DROP TABLE IF EXISTS `x_repository`;
CREATE TABLE `x_repository` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `repo_id` varchar(30) NOT NULL,
  `repo_name` varchar(50) DEFAULT NULL,
  `repo_username` varchar(50) DEFAULT NULL,
  `repo_password` varchar(50) DEFAULT NULL,
  `repo_type` varchar(10) DEFAULT NULL,
  `db_access` varchar(10) DEFAULT NULL,
  `db_host` varchar(50) DEFAULT NULL,
  `db_port` varchar(10) DEFAULT NULL,
  `db_name` varchar(20) DEFAULT NULL,
  `db_username` varchar(50) DEFAULT NULL,
  `db_password` varchar(50) DEFAULT NULL,
  `is_del` char(2) DEFAULT NULL,
  `created_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `type` varchar(10) DEFAULT NULL,
  `base_dir` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of x_repository
-- ----------------------------
BEGIN;
INSERT INTO `x_repository` VALUES (1, '1326379690046259200', '仁品资源库', 'admin', 'admin', 'MYSQL', 'Native', '192.168.3.166', '3306', 'kettle', 'root', 'root', '0', '2020-11-11 12:22:15', '2020-11-11 12:22:15', 'db', '');
COMMIT;

-- ----------------------------
-- Table structure for x_role
-- ----------------------------
DROP TABLE IF EXISTS `x_role`;
CREATE TABLE `x_role` (
  `role_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(30) NOT NULL,
  `role_key` varchar(100) NOT NULL,
  `role_sort` int(4) NOT NULL,
  `data_scope` char(1) DEFAULT '1',
  `menu_check_strictly` tinyint(1) DEFAULT '1',
  `dept_check_strictly` tinyint(1) DEFAULT '1',
  `status` char(1) NOT NULL,
  `del_flag` char(1) DEFAULT '0',
  `create_by` varchar(64) DEFAULT '',
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(64) DEFAULT '',
  `update_time` datetime DEFAULT NULL,
  `remark` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for x_role_dept
-- ----------------------------
DROP TABLE IF EXISTS `x_role_dept`;
CREATE TABLE `x_role_dept` (
  `role_id` bigint(20) NOT NULL,
  `dept_id` bigint(20) NOT NULL,
  PRIMARY KEY (`role_id`,`dept_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for x_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `x_role_menu`;
CREATE TABLE `x_role_menu` (
  `role_id` bigint(20) NOT NULL,
  `menu_id` bigint(20) NOT NULL,
  PRIMARY KEY (`role_id`,`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for x_template
-- ----------------------------
DROP TABLE IF EXISTS `x_template`;
CREATE TABLE `x_template` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `template_name` varchar(200) NOT NULL,
  `template_description` varchar(500) DEFAULT NULL,
  `created_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `template_key` varchar(150) DEFAULT NULL,
  `template_path` varchar(250) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of x_template
-- ----------------------------
BEGIN;
INSERT INTO `x_template` VALUES (1, 'SQL', '编写SQL脚本', '2021-02-02 11:19:24', '2021-02-02 11:19:24', 'sqlTpl', 'template/sqlTpl.kjb');
INSERT INTO `x_template` VALUES (2, 'SHELL', '编写SHELL脚本', '2021-02-02 11:20:22', '2021-02-02 11:20:22', 'shellTpl', 'template/shellTpl.kjb');
INSERT INTO `x_template` VALUES (3, 'JAVASCRIPT', '编写JAVASCRIPT脚本', '2021-02-02 11:21:07', '2021-02-02 11:21:07', 'javascriptTpl', 'template/javascriptTpl.kjb');
INSERT INTO `x_template` VALUES (4, '表对表全量', '先执行删除后全量同步', '2021-02-02 11:24:39', '2021-02-02 11:24:39', 'table2table', 'template/table2tableTpl.kjb');
INSERT INTO `x_template` VALUES (5, '表对表增量', '表与表之间增量更新', '2021-02-02 11:24:39', '2021-02-02 11:24:39', 'table2update', 'template/table2updateTpl.kjb');
INSERT INTO `x_template` VALUES (6, '表对表同步', '表与表之间增量同步', '2021-02-02 11:24:39', '2021-02-02 11:24:39', 'table2sync', 'template/table2syncTpl.kjb');
COMMIT;

-- ----------------------------
-- Table structure for x_trans
-- ----------------------------
DROP TABLE IF EXISTS `x_trans`;
CREATE TABLE `x_trans` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `trans_id` varchar(30) NOT NULL,
  `trans_name` varchar(200) NOT NULL,
  `trans_description` varchar(500) DEFAULT NULL,
  `trans_type` varchar(5) DEFAULT NULL,
  `trans_path` varchar(200) DEFAULT NULL,
  `trans_repository_id` varchar(30) DEFAULT NULL,
  `trans_log_level` varchar(10) DEFAULT NULL,
  `trans_status` varchar(10) DEFAULT NULL,
  `is_del` char(2) DEFAULT NULL,
  `created_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `is_monitor_enabled` char(2) DEFAULT NULL,
  `tpl_key` varchar(150) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for x_user
-- ----------------------------
DROP TABLE IF EXISTS `x_user`;
CREATE TABLE `x_user` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `dept_id` bigint(20) DEFAULT NULL,
  `user_name` varchar(30) NOT NULL,
  `nick_name` varchar(30) NOT NULL,
  `user_type` varchar(2) DEFAULT '00',
  `email` varchar(50) DEFAULT '',
  `phonenumber` varchar(11) DEFAULT '',
  `sex` char(1) DEFAULT '0',
  `avatar` varchar(100) DEFAULT '',
  `password` varchar(100) DEFAULT '',
  `status` char(1) DEFAULT '0',
  `del_flag` char(1) DEFAULT '0',
  `login_ip` varchar(128) DEFAULT '',
  `login_date` datetime DEFAULT NULL,
  `create_by` varchar(64) DEFAULT '',
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(64) DEFAULT '',
  `update_time` datetime DEFAULT NULL,
  `remark` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of x_user
-- ----------------------------
BEGIN;
INSERT INTO `x_user` VALUES (1, 103, 'admin', 'yuenbin', '00', 'yaukie@163.com', '15888888888', '1', 'admin-header.png', '33d67b47c430550a6e7fc86e38fadc9f', '0', '0', '127.0.0.1', '2021-05-15 11:45:45', 'admin', '2021-05-15 11:45:45', '', NULL, '管理员');
INSERT INTO `x_user` VALUES (2, 103, 'superadmin', 'yuenbin', '00', 'yaukie@163.com', '15888888888', '0', 'superadmin-header.png', '33d67b47c430550a6e7fc86e38fadc9f', '0', '0', '127.0.0.1', '2021-05-19 16:05:10', 'superadmin', '2021-05-19 16:05:14', '', NULL, '超级管理员');
COMMIT;

-- ----------------------------
-- Table structure for x_user_post
-- ----------------------------
DROP TABLE IF EXISTS `x_user_post`;
CREATE TABLE `x_user_post` (
  `user_id` bigint(20) NOT NULL,
  `post_id` bigint(20) NOT NULL,
  PRIMARY KEY (`user_id`,`post_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of x_user_post
-- ----------------------------
BEGIN;
INSERT INTO `x_user_post` VALUES (1, 1);
INSERT INTO `x_user_post` VALUES (2, 2);
COMMIT;

-- ----------------------------
-- Table structure for x_user_role
-- ----------------------------
DROP TABLE IF EXISTS `x_user_role`;
CREATE TABLE `x_user_role` (
  `user_id` bigint(20) NOT NULL,
  `role_id` bigint(20) NOT NULL,
  PRIMARY KEY (`user_id`,`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of x_user_role
-- ----------------------------
BEGIN;
INSERT INTO `x_user_role` VALUES (1, 1);
INSERT INTO `x_user_role` VALUES (2, 2);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
